from google.colab import drive
drive.mount('/content/drive')
Mounted at /content/drive
%%shell
jupyter nbconvert --to html /content/.ipynb
data = pd.read_csv('/content/drive/MyDrive/menu.csv')
data
| Category | Item | Serving Size | Calories | Calories from Fat | Total Fat | Total Fat (% Daily Value) | Saturated Fat | Saturated Fat (% Daily Value) | Trans Fat | Cholesterol | Cholesterol (% Daily Value) | Sodium | Sodium (% Daily Value) | Carbohydrates | Carbohydrates (% Daily Value) | Dietary Fiber | Dietary Fiber (% Daily Value) | Sugars | Protein | Vitamin A (% Daily Value) | Vitamin C (% Daily Value) | Calcium (% Daily Value) | Iron (% Daily Value) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Breakfast | Egg McMuffin | 4.8 oz (136 g) | 300 | 120 | 13.0 | 20 | 5.0 | 25 | 0.0 | 260 | 87 | 750 | 31 | 31 | 10 | 4 | 17 | 3 | 17 | 10 | 0 | 25 | 15 |
| 1 | Breakfast | Egg White Delight | 4.8 oz (135 g) | 250 | 70 | 8.0 | 12 | 3.0 | 15 | 0.0 | 25 | 8 | 770 | 32 | 30 | 10 | 4 | 17 | 3 | 18 | 6 | 0 | 25 | 8 |
| 2 | Breakfast | Sausage McMuffin | 3.9 oz (111 g) | 370 | 200 | 23.0 | 35 | 8.0 | 42 | 0.0 | 45 | 15 | 780 | 33 | 29 | 10 | 4 | 17 | 2 | 14 | 8 | 0 | 25 | 10 |
| 3 | Breakfast | Sausage McMuffin with Egg | 5.7 oz (161 g) | 450 | 250 | 28.0 | 43 | 10.0 | 52 | 0.0 | 285 | 95 | 860 | 36 | 30 | 10 | 4 | 17 | 2 | 21 | 15 | 0 | 30 | 15 |
| 4 | Breakfast | Sausage McMuffin with Egg Whites | 5.7 oz (161 g) | 400 | 210 | 23.0 | 35 | 8.0 | 42 | 0.0 | 50 | 16 | 880 | 37 | 30 | 10 | 4 | 17 | 2 | 21 | 6 | 0 | 25 | 10 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 255 | Smoothies & Shakes | McFlurry with Oreo Cookies (Small) | 10.1 oz (285 g) | 510 | 150 | 17.0 | 26 | 9.0 | 44 | 0.5 | 45 | 14 | 280 | 12 | 80 | 27 | 1 | 4 | 64 | 12 | 15 | 0 | 40 | 8 |
| 256 | Smoothies & Shakes | McFlurry with Oreo Cookies (Medium) | 13.4 oz (381 g) | 690 | 200 | 23.0 | 35 | 12.0 | 58 | 1.0 | 55 | 19 | 380 | 16 | 106 | 35 | 1 | 5 | 85 | 15 | 20 | 0 | 50 | 10 |
| 257 | Smoothies & Shakes | McFlurry with Oreo Cookies (Snack) | 6.7 oz (190 g) | 340 | 100 | 11.0 | 17 | 6.0 | 29 | 0.0 | 30 | 9 | 190 | 8 | 53 | 18 | 1 | 2 | 43 | 8 | 10 | 0 | 25 | 6 |
| 258 | Smoothies & Shakes | McFlurry with Reese's Peanut Butter Cups (Medium) | 14.2 oz (403 g) | 810 | 290 | 32.0 | 50 | 15.0 | 76 | 1.0 | 60 | 20 | 400 | 17 | 114 | 38 | 2 | 9 | 103 | 21 | 20 | 0 | 60 | 6 |
| 259 | Smoothies & Shakes | McFlurry with Reese's Peanut Butter Cups (Snack) | 7.1 oz (202 g) | 410 | 150 | 16.0 | 25 | 8.0 | 38 | 0.0 | 30 | 10 | 200 | 8 | 57 | 19 | 1 | 5 | 51 | 10 | 10 | 0 | 30 | 4 |
260 rows × 24 columns
lists = data['Category'].unique().tolist()
for list in lists:
#items ascending=False
items=data.query('Category == list').sort_values(by="Calories", ascending=False)
items_custom=items.iloc[:,[1,3,5]]
#items ascending=True
items_t=data.query('Category == list').sort_values(by="Calories", ascending=True)
items_custom_t=items_t.iloc[:,[1,3,5]]
#Print Categories
print(lists.index(list)+1,".",list)
#Plotly Express
p_express = px.scatter(items_custom, x="Total Fat",y='Calories', color="Item",size='Calories',
template="plotly_dark",hover_name="Item")
p_express.show()
#Display Tables ranked by calories
table=items_custom.iloc[:,[0,1,2]].sort_values(by="Calories", ascending=False).style.hide_index()
#table=table.style.hide_index()
display(table)
#Matplotlib pyplot
fig,ax=plt.subplots()
x=items_custom_t.iloc[:,0]
y=items_custom_t.iloc[:,1]
ax.barh(x, y, tick_label=x, align='edge')
plt.show()
1 . Breakfast
| Item | Calories | Total Fat |
|---|---|---|
| Big Breakfast with Hotcakes (Large Biscuit) | 1150 | 60.000000 |
| Big Breakfast with Hotcakes (Regular Biscuit) | 1090 | 56.000000 |
| Big Breakfast with Hotcakes and Egg Whites (Large Biscuit) | 1050 | 50.000000 |
| Big Breakfast with Hotcakes and Egg Whites (Regular Biscuit) | 990 | 46.000000 |
| Big Breakfast (Large Biscuit) | 800 | 52.000000 |
| Big Breakfast (Regular Biscuit) | 740 | 48.000000 |
| Big Breakfast with Egg Whites (Large Biscuit) | 690 | 41.000000 |
| Steak, Egg & Cheese Bagel | 670 | 35.000000 |
| Big Breakfast with Egg Whites (Regular Biscuit) | 640 | 37.000000 |
| Bacon, Egg & Cheese Bagel | 620 | 31.000000 |
| Sausage Biscuit with Egg (Large Biscuit) | 570 | 37.000000 |
| Bacon, Egg & Cheese Bagel with Egg Whites | 570 | 25.000000 |
| Sausage, Egg & Cheese McGriddles | 550 | 31.000000 |
| Steak & Egg Biscuit (Regular Biscuit) | 540 | 32.000000 |
| Sausage Biscuit with Egg Whites (Large Biscuit) | 520 | 32.000000 |
| Hotcakes and Sausage | 520 | 24.000000 |
| Bacon, Egg & Cheese Biscuit (Large Biscuit) | 520 | 30.000000 |
| Sausage Biscuit with Egg (Regular Biscuit) | 510 | 33.000000 |
| Sausage, Egg & Cheese McGriddles with Egg Whites | 500 | 26.000000 |
| Sausage Biscuit (Large Biscuit) | 480 | 31.000000 |
| Bacon, Egg & Cheese Biscuit with Egg Whites (Large Biscuit) | 470 | 25.000000 |
| Southern Style Chicken Biscuit (Large Biscuit) | 470 | 24.000000 |
| Bacon, Egg & Cheese McGriddles | 460 | 21.000000 |
| Cinnamon Melts | 460 | 19.000000 |
| Sausage Biscuit with Egg Whites (Regular Biscuit) | 460 | 27.000000 |
| Bacon, Egg & Cheese Biscuit (Regular Biscuit) | 460 | 26.000000 |
| Sausage McMuffin with Egg | 450 | 28.000000 |
| Sausage Biscuit (Regular Biscuit) | 430 | 27.000000 |
| Steak & Egg McMuffin | 430 | 23.000000 |
| Sausage McGriddles | 420 | 22.000000 |
| Southern Style Chicken Biscuit (Regular Biscuit) | 410 | 20.000000 |
| Bacon, Egg & Cheese Biscuit with Egg Whites (Regular Biscuit) | 410 | 20.000000 |
| Bacon, Egg & Cheese McGriddles with Egg Whites | 400 | 15.000000 |
| Sausage McMuffin with Egg Whites | 400 | 23.000000 |
| Sausage McMuffin | 370 | 23.000000 |
| Hotcakes | 350 | 9.000000 |
| Sausage Burrito | 300 | 16.000000 |
| Egg McMuffin | 300 | 13.000000 |
| Fruit & Maple Oatmeal | 290 | 4.000000 |
| Fruit & Maple Oatmeal without Brown Sugar | 260 | 4.000000 |
| Egg White Delight | 250 | 8.000000 |
| Hash Brown | 150 | 9.000000 |
2 . Beef & Pork
| Item | Calories | Total Fat |
|---|---|---|
| Double Quarter Pounder with Cheese | 750 | 43.000000 |
| Bacon Clubhouse Burger | 720 | 40.000000 |
| Quarter Pounder with Bacon Habanero Ranch | 610 | 31.000000 |
| Quarter Pounder with Bacon & Cheese | 600 | 29.000000 |
| Quarter Pounder Deluxe | 540 | 27.000000 |
| Big Mac | 530 | 27.000000 |
| Quarter Pounder with Cheese | 520 | 26.000000 |
| McRib | 500 | 26.000000 |
| Bacon McDouble | 440 | 22.000000 |
| Double Cheeseburger | 430 | 21.000000 |
| Daily Double | 430 | 22.000000 |
| Jalapeño Double | 430 | 23.000000 |
| McDouble | 380 | 17.000000 |
| Cheeseburger | 290 | 11.000000 |
| Hamburger | 240 | 8.000000 |
3 . Chicken & Fish
| Item | Calories | Total Fat |
|---|---|---|
| Chicken McNuggets (40 piece) | 1880 | 118.000000 |
| Chicken McNuggets (20 piece) | 940 | 59.000000 |
| Bacon Clubhouse Crispy Chicken Sandwich | 750 | 38.000000 |
| Premium Crispy Chicken Club Sandwich | 670 | 33.000000 |
| Premium McWrap Southwest Chicken (Crispy Chicken) | 670 | 33.000000 |
| Premium McWrap Chicken & Bacon (Crispy Chicken) | 630 | 32.000000 |
| Premium McWrap Chicken & Ranch (Crispy Chicken) | 610 | 31.000000 |
| Premium Crispy Chicken Ranch BLT Sandwich | 610 | 28.000000 |
| Bacon Clubhouse Grilled Chicken Sandwich | 590 | 25.000000 |
| Premium McWrap Chicken Sweet Chili (Crispy Chicken) | 540 | 23.000000 |
| Premium McWrap Southwest Chicken (Grilled Chicken) | 520 | 20.000000 |
| Premium Crispy Chicken Classic Sandwich | 510 | 22.000000 |
| Premium Grilled Chicken Club Sandwich | 510 | 20.000000 |
| Bacon Cheddar McChicken | 480 | 24.000000 |
| Premium McWrap Chicken & Bacon (Grilled Chicken) | 480 | 19.000000 |
| Chicken McNuggets (10 piece) | 470 | 30.000000 |
| Premium McWrap Chicken & Ranch (Grilled Chicken) | 450 | 18.000000 |
| Premium Grilled Chicken Ranch BLT Sandwich | 450 | 15.000000 |
| Bacon Buffalo Ranch McChicken | 430 | 21.000000 |
| Southern Style Crispy Chicken Sandwich | 430 | 19.000000 |
| Filet-O-Fish | 390 | 19.000000 |
| Premium McWrap Chicken Sweet Chili (Grilled Chicken) | 380 | 10.000000 |
| Buffalo Ranch McChicken | 360 | 16.000000 |
| McChicken | 360 | 16.000000 |
| Premium Grilled Chicken Classic Sandwich | 350 | 9.000000 |
| Chicken McNuggets (6 piece) | 280 | 18.000000 |
| Chicken McNuggets (4 piece) | 190 | 12.000000 |
4 . Salads
| Item | Calories | Total Fat |
|---|---|---|
| Premium Southwest Salad with Crispy Chicken | 450 | 22.000000 |
| Premium Bacon Ranch Salad with Crispy Chicken | 380 | 21.000000 |
| Premium Southwest Salad with Grilled Chicken | 290 | 8.000000 |
| Premium Bacon Ranch Salad with Grilled Chicken | 220 | 8.000000 |
| Premium Bacon Ranch Salad (without Chicken) | 140 | 7.000000 |
| Premium Southwest Salad (without Chicken) | 140 | 4.500000 |
5 . Snacks & Sides
| Item | Calories | Total Fat |
|---|---|---|
| Large French Fries | 510 | 24.000000 |
| Ranch Snack Wrap (Crispy Chicken) | 360 | 20.000000 |
| Chipotle BBQ Snack Wrap (Crispy Chicken) | 340 | 15.000000 |
| Medium French Fries | 340 | 16.000000 |
| Honey Mustard Snack Wrap (Crispy Chicken) | 330 | 15.000000 |
| Ranch Snack Wrap (Grilled Chicken) | 280 | 13.000000 |
| Chipotle BBQ Snack Wrap (Grilled Chicken) | 260 | 8.000000 |
| Honey Mustard Snack Wrap (Grilled Chicken) | 250 | 8.000000 |
| Small French Fries | 230 | 11.000000 |
| Fruit 'n Yogurt Parfait | 150 | 2.000000 |
| Kids French Fries | 110 | 5.000000 |
| Side Salad | 20 | 0.000000 |
| Apple Slices | 15 | 0.000000 |
6 . Desserts
| Item | Calories | Total Fat |
|---|---|---|
| Hot Caramel Sundae | 340 | 8.000000 |
| Hot Fudge Sundae | 330 | 9.000000 |
| Strawberry Sundae | 280 | 6.000000 |
| Baked Apple Pie | 250 | 13.000000 |
| Chocolate Chip Cookie | 160 | 8.000000 |
| Oatmeal Raisin Cookie | 150 | 6.000000 |
| Kids Ice Cream Cone | 45 | 1.500000 |
7 . Beverages
| Item | Calories | Total Fat |
|---|---|---|
| Sprite (Large) | 280 | 0.000000 |
| Minute Maid Orange Juice (Large) | 280 | 0.000000 |
| Coca-Cola Classic (Large) | 280 | 0.000000 |
| Dr Pepper (Large) | 270 | 0.000000 |
| Sprite (Medium) | 200 | 0.000000 |
| Coca-Cola Classic (Medium) | 200 | 0.000000 |
| Dr Pepper (Medium) | 190 | 0.000000 |
| Minute Maid Orange Juice (Medium) | 190 | 0.000000 |
| Minute Maid Orange Juice (Small) | 150 | 0.000000 |
| Dr Pepper (Small) | 140 | 0.000000 |
| Sprite (Small) | 140 | 0.000000 |
| Coca-Cola Classic (Small) | 140 | 0.000000 |
| Fat Free Chocolate Milk Jug | 130 | 0.000000 |
| 1% Low Fat Milk Jug | 100 | 2.500000 |
| Sprite (Child) | 100 | 0.000000 |
| Dr Pepper (Child) | 100 | 0.000000 |
| Coca-Cola Classic (Child) | 100 | 0.000000 |
| Minute Maid 100% Apple Juice Box | 80 | 0.000000 |
| Diet Dr Pepper (Medium) | 0 | 0.000000 |
| Diet Dr Pepper (Child) | 0 | 0.000000 |
| Diet Dr Pepper (Large) | 0 | 0.000000 |
| Diet Dr Pepper (Small) | 0 | 0.000000 |
| Diet Coke (Child) | 0 | 0.000000 |
| Diet Coke (Large) | 0 | 0.000000 |
| Diet Coke (Medium) | 0 | 0.000000 |
| Diet Coke (Small) | 0 | 0.000000 |
| Dasani Water Bottle | 0 | 0.000000 |
8 . Coffee & Tea
| Item | Calories | Total Fat |
|---|---|---|
| Frappé Chocolate Chip (Large) | 760 | 31.000000 |
| Frappé Mocha (Large) | 670 | 26.000000 |
| Frappé Caramel (Large) | 670 | 27.000000 |
| Frappé Chocolate Chip (Medium) | 630 | 26.000000 |
| Frappé Caramel (Medium) | 550 | 23.000000 |
| Frappé Mocha (Medium) | 550 | 22.000000 |
| Hot Chocolate (Large) | 540 | 20.000000 |
| Frappé Chocolate Chip (Small) | 530 | 23.000000 |
| Mocha (Large) | 500 | 17.000000 |
| Caramel Mocha (Large) | 480 | 17.000000 |
| Iced Mocha (Large) | 480 | 16.000000 |
| Iced Caramel Mocha (Large) | 460 | 16.000000 |
| Frappé Caramel (Small) | 450 | 19.000000 |
| Frappé Mocha (Small) | 450 | 18.000000 |
| Hot Chocolate (Medium) | 440 | 16.000000 |
| Hazelnut Latte (Large) | 430 | 14.000000 |
| Caramel Latte (Large) | 430 | 14.000000 |
| French Vanilla Latte (Large) | 420 | 14.000000 |
| Mocha (Medium) | 410 | 14.000000 |
| Hot Chocolate with Nonfat Milk (Large) | 400 | 3.500000 |
| Iced Mocha with Nonfat Milk (Large) | 390 | 6.000000 |
| Caramel Mocha (Medium) | 390 | 14.000000 |
| Mocha with Nonfat Milk (Large) | 390 | 4.000000 |
| Iced Nonfat Caramel Mocha (Large) | 370 | 6.000000 |
| Nonfat Caramel Mocha (Large) | 370 | 3.500000 |
| Hot Chocolate (Small) | 360 | 13.000000 |
| Iced Mocha (Medium) | 350 | 13.000000 |
| Mocha (Small) | 340 | 11.000000 |
| Hot Chocolate with Nonfat Milk (Medium) | 340 | 3.500000 |
| Caramel Latte (Medium) | 340 | 10.000000 |
| Iced Caramel Mocha (Medium) | 340 | 13.000000 |
| Hazelnut Latte (Medium) | 330 | 10.000000 |
| French Vanilla Latte (Medium) | 330 | 10.000000 |
| Latte with Sugar Free French Vanilla Syrup (Large) | 330 | 14.000000 |
| Mocha with Nonfat Milk (Medium) | 330 | 3.500000 |
| Caramel Mocha (Small) | 320 | 11.000000 |
| Nonfat Caramel Mocha (Medium) | 310 | 3.500000 |
| Nonfat Hazelnut Latte (Large) | 310 | 0.500000 |
| Nonfat Caramel Latte (Large) | 310 | 0.500000 |
| Nonfat French Vanilla Latte (Large) | 300 | 0.500000 |
| Iced Mocha with Nonfat Milk (Medium) | 290 | 5.000000 |
| Iced Mocha (Small) | 290 | 11.000000 |
| Latte (Large) | 280 | 14.000000 |
| Iced Caramel Mocha (Small) | 280 | 11.000000 |
| Hot Chocolate with Nonfat Milk (Small) | 280 | 3.500000 |
| Regular Iced Coffee (Large) | 270 | 9.000000 |
| Iced Nonfat Caramel Mocha (Medium) | 270 | 5.000000 |
| Mocha with Nonfat Milk (Small) | 270 | 3.500000 |
| Hazelnut Latte (Small) | 270 | 9.000000 |
| Caramel Latte (Small) | 270 | 9.000000 |
| Latte with Sugar Free French Vanilla Syrup (Medium) | 260 | 10.000000 |
| French Vanilla Latte (Small) | 260 | 9.000000 |
| Caramel Iced Coffee (Large) | 260 | 9.000000 |
| Nonfat Caramel Mocha (Small) | 250 | 3.500000 |
| Nonfat Caramel Latte (Medium) | 250 | 0.000000 |
| Nonfat Hazelnut Latte (Medium) | 250 | 0.000000 |
| Hazelnut Iced Coffee (Large) | 250 | 9.000000 |
| French Vanilla Iced Coffee (Large) | 240 | 9.000000 |
| Iced Mocha with Nonfat Milk (Small) | 240 | 5.000000 |
| Nonfat French Vanilla Latte (Medium) | 240 | 0.000000 |
| Iced Nonfat Caramel Mocha (Small) | 230 | 5.000000 |
| Nonfat Latte with Sugar Free French Vanilla Syrup (Large) | 220 | 0.500000 |
| Sweet Tea (Large) | 220 | 0.000000 |
| Latte with Sugar Free French Vanilla Syrup (Small) | 210 | 9.000000 |
| Latte (Medium) | 210 | 10.000000 |
| Nonfat Caramel Latte (Small) | 200 | 0.000000 |
| Nonfat Hazelnut Latte (Small) | 200 | 0.000000 |
| Regular Iced Coffee (Medium) | 190 | 7.000000 |
| Nonfat French Vanilla Latte (Small) | 190 | 0.000000 |
| Caramel Iced Coffee (Medium) | 180 | 7.000000 |
| Hazelnut Iced Coffee (Medium) | 180 | 7.000000 |
| Sweet Tea (Medium) | 180 | 0.000000 |
| Latte (Small) | 170 | 9.000000 |
| Nonfat Latte with Sugar Free French Vanilla Syrup (Medium) | 170 | 0.000000 |
| Nonfat Latte (Large) | 170 | 0.500000 |
| French Vanilla Iced Coffee (Medium) | 170 | 7.000000 |
| Iced Coffee with Sugar Free French Vanilla Syrup (Large) | 160 | 9.000000 |
| Sweet Tea (Small) | 150 | 0.000000 |
| Regular Iced Coffee (Small) | 140 | 4.500000 |
| Nonfat Latte with Sugar Free French Vanilla Syrup (Small) | 140 | 0.000000 |
| Hazelnut Iced Coffee (Small) | 130 | 4.500000 |
| Caramel Iced Coffee (Small) | 130 | 4.500000 |
| Nonfat Latte (Medium) | 130 | 0.000000 |
| French Vanilla Iced Coffee (Small) | 120 | 4.500000 |
| Iced Coffee with Sugar Free French Vanilla Syrup (Medium) | 120 | 7.000000 |
| Sweet Tea (Child) | 110 | 0.000000 |
| Nonfat Latte (Small) | 100 | 0.000000 |
| Iced Coffee with Sugar Free French Vanilla Syrup (Small) | 80 | 4.500000 |
| Coffee (Large) | 0 | 0.000000 |
| Coffee (Medium) | 0 | 0.000000 |
| Coffee (Small) | 0 | 0.000000 |
| Iced Tea (Medium) | 0 | 0.000000 |
| Iced Tea (Child) | 0 | 0.000000 |
| Iced Tea (Large) | 0 | 0.000000 |
| Iced Tea (Small) | 0 | 0.000000 |
9 . Smoothies & Shakes
| Item | Calories | Total Fat |
|---|---|---|
| McFlurry with M&M’s Candies (Medium) | 930 | 33.000000 |
| Strawberry Shake (Large) | 850 | 24.000000 |
| Chocolate Shake (Large) | 850 | 23.000000 |
| Vanilla Shake (Large) | 820 | 23.000000 |
| Shamrock Shake (Large) | 820 | 23.000000 |
| McFlurry with Reese's Peanut Butter Cups (Medium) | 810 | 32.000000 |
| Chocolate Shake (Medium) | 700 | 20.000000 |
| McFlurry with Oreo Cookies (Medium) | 690 | 23.000000 |
| Strawberry Shake (Medium) | 690 | 20.000000 |
| Vanilla Shake (Medium) | 660 | 19.000000 |
| Shamrock Shake (Medium) | 660 | 19.000000 |
| McFlurry with M&M’s Candies (Small) | 650 | 23.000000 |
| Chocolate Shake (Small) | 560 | 16.000000 |
| Strawberry Shake (Small) | 550 | 16.000000 |
| Vanilla Shake (Small) | 530 | 15.000000 |
| McFlurry with Oreo Cookies (Small) | 510 | 17.000000 |
| McFlurry with M&M’s Candies (Snack) | 430 | 15.000000 |
| McFlurry with Reese's Peanut Butter Cups (Snack) | 410 | 16.000000 |
| Mango Pineapple Smoothie (Large) | 340 | 1.000000 |
| McFlurry with Oreo Cookies (Snack) | 340 | 11.000000 |
| Blueberry Pomegranate Smoothie (Large) | 340 | 1.000000 |
| Strawberry Banana Smoothie (Large) | 330 | 1.000000 |
| Blueberry Pomegranate Smoothie (Medium) | 260 | 1.000000 |
| Mango Pineapple Smoothie (Medium) | 260 | 1.000000 |
| Strawberry Banana Smoothie (Medium) | 250 | 1.000000 |
| Blueberry Pomegranate Smoothie (Small) | 220 | 0.500000 |
| Mango Pineapple Smoothie (Small) | 210 | 0.500000 |
| Strawberry Banana Smoothie (Small) | 210 | 0.500000 |
for list in lists:
#items ascending=False
items=data.query('Category == list').sort_values(by="Cholesterol", ascending=False)
items_custom=items.iloc[:,[1,10,19]]
#items ascending=True
items_t=data.query('Category == list').sort_values(by="Cholesterol", ascending=True)
items_custom_t=items_t.iloc[:,[1,10,19]]
#Print Categories
print(lists.index(list)+1,".",list)
#Plotly Express
p_express = px.scatter(items_custom, x="Protein",y='Cholesterol', color="Item",size='Cholesterol',
template="plotly_dark",hover_name="Item")
p_express.show()
#Display Tables ranked by calories
table=items_custom.iloc[:,[0,1, 2]].sort_values(by="Cholesterol", ascending=False).style.hide_index()
#table=table.style.hide_index()
display(table)
#Matplotlib pyplot
fig,ax=plt.subplots()
x=items_custom_t.iloc[:,0]
y=items_custom_t.iloc[:,1]
ax.barh(x,y, linewidth=0, tick_label=x)
plt.show()
1 . Breakfast
| Item | Cholesterol | Protein |
|---|---|---|
| Big Breakfast with Hotcakes (Regular Biscuit) | 575 | 36 |
| Big Breakfast with Hotcakes (Large Biscuit) | 575 | 36 |
| Big Breakfast (Regular Biscuit) | 555 | 28 |
| Big Breakfast (Large Biscuit) | 555 | 28 |
| Steak & Egg McMuffin | 300 | 26 |
| Steak, Egg & Cheese Bagel | 295 | 33 |
| Sausage McMuffin with Egg | 285 | 21 |
| Steak & Egg Biscuit (Regular Biscuit) | 280 | 25 |
| Bacon, Egg & Cheese Bagel | 275 | 30 |
| Sausage, Egg & Cheese McGriddles | 265 | 20 |
| Egg McMuffin | 260 | 17 |
| Bacon, Egg & Cheese McGriddles | 250 | 19 |
| Sausage Biscuit with Egg (Large Biscuit) | 250 | 18 |
| Sausage Biscuit with Egg (Regular Biscuit) | 250 | 18 |
| Bacon, Egg & Cheese Biscuit (Large Biscuit) | 250 | 19 |
| Bacon, Egg & Cheese Biscuit (Regular Biscuit) | 250 | 19 |
| Sausage Burrito | 115 | 12 |
| Bacon, Egg & Cheese Bagel with Egg Whites | 60 | 30 |
| Big Breakfast with Hotcakes and Egg Whites (Regular Biscuit) | 55 | 35 |
| Big Breakfast with Hotcakes and Egg Whites (Large Biscuit) | 55 | 35 |
| Sausage, Egg & Cheese McGriddles with Egg Whites | 50 | 21 |
| Sausage McMuffin with Egg Whites | 50 | 21 |
| Hotcakes and Sausage | 50 | 15 |
| Sausage McMuffin | 45 | 14 |
| Big Breakfast with Egg Whites (Large Biscuit) | 35 | 26 |
| Big Breakfast with Egg Whites (Regular Biscuit) | 35 | 26 |
| Sausage McGriddles | 35 | 11 |
| Bacon, Egg & Cheese McGriddles with Egg Whites | 35 | 20 |
| Sausage Biscuit with Egg Whites (Large Biscuit) | 35 | 18 |
| Sausage Biscuit with Egg Whites (Regular Biscuit) | 35 | 18 |
| Bacon, Egg & Cheese Biscuit with Egg Whites (Large Biscuit) | 35 | 20 |
| Bacon, Egg & Cheese Biscuit with Egg Whites (Regular Biscuit) | 35 | 20 |
| Sausage Biscuit (Large Biscuit) | 30 | 11 |
| Sausage Biscuit (Regular Biscuit) | 30 | 11 |
| Southern Style Chicken Biscuit (Large Biscuit) | 30 | 17 |
| Southern Style Chicken Biscuit (Regular Biscuit) | 30 | 17 |
| Egg White Delight | 25 | 18 |
| Hotcakes | 20 | 8 |
| Cinnamon Melts | 15 | 6 |
| Fruit & Maple Oatmeal | 5 | 5 |
| Fruit & Maple Oatmeal without Brown Sugar | 5 | 5 |
| Hash Brown | 0 | 1 |
2 . Beef & Pork
| Item | Cholesterol | Protein |
|---|---|---|
| Double Quarter Pounder with Cheese | 160 | 48 |
| Bacon Clubhouse Burger | 115 | 39 |
| Quarter Pounder with Bacon & Cheese | 105 | 37 |
| Quarter Pounder with Bacon Habanero Ranch | 105 | 37 |
| Quarter Pounder with Cheese | 95 | 30 |
| Double Cheeseburger | 90 | 24 |
| Bacon McDouble | 90 | 27 |
| Big Mac | 85 | 24 |
| Quarter Pounder Deluxe | 85 | 29 |
| Daily Double | 80 | 22 |
| Jalapeño Double | 80 | 22 |
| McDouble | 75 | 22 |
| McRib | 70 | 22 |
| Cheeseburger | 45 | 15 |
| Hamburger | 30 | 12 |
3 . Chicken & Fish
| Item | Cholesterol | Protein |
|---|---|---|
| Chicken McNuggets (40 piece) | 265 | 87 |
| Chicken McNuggets (20 piece) | 135 | 44 |
| Bacon Clubhouse Grilled Chicken Sandwich | 110 | 40 |
| Premium Grilled Chicken Club Sandwich | 105 | 40 |
| Premium McWrap Chicken & Bacon (Grilled Chicken) | 95 | 36 |
| Premium Grilled Chicken Ranch BLT Sandwich | 90 | 36 |
| Bacon Clubhouse Crispy Chicken Sandwich | 90 | 36 |
| Premium Crispy Chicken Club Sandwich | 85 | 36 |
| Premium McWrap Chicken & Bacon (Crispy Chicken) | 80 | 32 |
| Premium McWrap Southwest Chicken (Grilled Chicken) | 80 | 31 |
| Premium McWrap Chicken & Ranch (Grilled Chicken) | 80 | 30 |
| Premium Crispy Chicken Ranch BLT Sandwich | 70 | 32 |
| Chicken McNuggets (10 piece) | 65 | 22 |
| Premium McWrap Chicken Sweet Chili (Grilled Chicken) | 65 | 27 |
| Bacon Cheddar McChicken | 65 | 22 |
| Premium Grilled Chicken Classic Sandwich | 65 | 28 |
| Premium McWrap Chicken & Ranch (Crispy Chicken) | 65 | 27 |
| Premium McWrap Southwest Chicken (Crispy Chicken) | 60 | 27 |
| Bacon Buffalo Ranch McChicken | 50 | 20 |
| Premium McWrap Chicken Sweet Chili (Crispy Chicken) | 50 | 23 |
| Premium Crispy Chicken Classic Sandwich | 45 | 24 |
| Southern Style Crispy Chicken Sandwich | 45 | 21 |
| Chicken McNuggets (6 piece) | 40 | 13 |
| Filet-O-Fish | 40 | 15 |
| Buffalo Ranch McChicken | 35 | 14 |
| McChicken | 35 | 14 |
| Chicken McNuggets (4 piece) | 25 | 9 |
4 . Salads
| Item | Cholesterol | Protein |
|---|---|---|
| Premium Bacon Ranch Salad with Grilled Chicken | 85 | 29 |
| Premium Bacon Ranch Salad with Crispy Chicken | 70 | 25 |
| Premium Southwest Salad with Grilled Chicken | 70 | 27 |
| Premium Southwest Salad with Crispy Chicken | 50 | 23 |
| Premium Bacon Ranch Salad (without Chicken) | 25 | 9 |
| Premium Southwest Salad (without Chicken) | 10 | 6 |
5 . Snacks & Sides
| Item | Cholesterol | Protein |
|---|---|---|
| Honey Mustard Snack Wrap (Grilled Chicken) | 45 | 16 |
| Ranch Snack Wrap (Grilled Chicken) | 45 | 16 |
| Chipotle BBQ Snack Wrap (Grilled Chicken) | 40 | 16 |
| Ranch Snack Wrap (Crispy Chicken) | 40 | 15 |
| Honey Mustard Snack Wrap (Crispy Chicken) | 35 | 14 |
| Chipotle BBQ Snack Wrap (Crispy Chicken) | 30 | 14 |
| Fruit 'n Yogurt Parfait | 5 | 4 |
| Small French Fries | 0 | 2 |
| Medium French Fries | 0 | 4 |
| Large French Fries | 0 | 6 |
| Kids French Fries | 0 | 1 |
| Side Salad | 0 | 1 |
| Apple Slices | 0 | 0 |
6 . Desserts
| Item | Cholesterol | Protein |
|---|---|---|
| Hot Caramel Sundae | 30 | 7 |
| Hot Fudge Sundae | 25 | 8 |
| Strawberry Sundae | 25 | 6 |
| Chocolate Chip Cookie | 10 | 2 |
| Oatmeal Raisin Cookie | 10 | 2 |
| Kids Ice Cream Cone | 5 | 1 |
| Baked Apple Pie | 0 | 2 |
7 . Beverages
| Item | Cholesterol | Protein |
|---|---|---|
| 1% Low Fat Milk Jug | 10 | 8 |
| Fat Free Chocolate Milk Jug | 5 | 9 |
| Coca-Cola Classic (Medium) | 0 | 0 |
| Coca-Cola Classic (Large) | 0 | 0 |
| Coca-Cola Classic (Child) | 0 | 0 |
| Diet Coke (Small) | 0 | 0 |
| Diet Coke (Medium) | 0 | 0 |
| Diet Coke (Large) | 0 | 0 |
| Diet Coke (Child) | 0 | 0 |
| Dr Pepper (Small) | 0 | 0 |
| Dr Pepper (Medium) | 0 | 0 |
| Dr Pepper (Large) | 0 | 0 |
| Dr Pepper (Child) | 0 | 0 |
| Diet Dr Pepper (Small) | 0 | 2 |
| Diet Dr Pepper (Medium) | 0 | 3 |
| Diet Dr Pepper (Child) | 0 | 1 |
| Sprite (Small) | 0 | 0 |
| Sprite (Medium) | 0 | 0 |
| Sprite (Large) | 0 | 0 |
| Sprite (Child) | 0 | 0 |
| Minute Maid 100% Apple Juice Box | 0 | 0 |
| Minute Maid Orange Juice (Small) | 0 | 2 |
| Minute Maid Orange Juice (Medium) | 0 | 3 |
| Minute Maid Orange Juice (Large) | 0 | 4 |
| Diet Dr Pepper (Large) | 0 | 4 |
| Coca-Cola Classic (Small) | 0 | 0 |
| Dasani Water Bottle | 0 | 0 |
8 . Coffee & Tea